Table Settings

In the <Table_Name> - Table Settings window, you can define how the data for each individual table/view is replicated to the target.

To open the Table Settings window:

1. Open the task you are working with.

   For information on opening a task, see Editing a replication task.

2. In Designer view, select the desired table from one of the following tabs on the right of the console:

   • The Patterns and Selected Tables tab - if the desired table was explicitly selected.

   • The Full Table List tab - if the desired table was selected using a table inclusion pattern.

     For information on how to define table selection patterns, see Creating table/view selection patterns.

3. Click the Table Settings button above the table list.

   The <Table_Name> - Table Settings window opens.

4. In the Table Settings window, perform any of the following tasks:

   • Performing General tasks for a single table/view
   • Defining transformations for a single table/view
   • Using filters
   • Parallel Load
   • Handling LOB columns
   • Message format
   • Full Load
5. Click OK to close the Table Settings window.
6. Click Save in the main toolbar to preserve the table and column information for this task.

To restore the default table values:

• Click Restore Table Defaults at the bottom left of the Table Settings window. This option is available in all tabs.

  Any changes you made will be discarded and the table's default settings will be restored.